﻿CREATE TABLE [dbo].[ChamberDocumentSearchResults] (
    [Id]               NVARCHAR (100) NOT NULL,
    [Title]            NVARCHAR (MAX) NOT NULL,
    [IndexedContent]   NVARCHAR (MAX) NOT NULL,
    [Date]             DATETIME       NOT NULL,
    [Summary]          NVARCHAR (MAX) NOT NULL,
    [DocumentType]     NVARCHAR (MAX) NOT NULL,
    [ParliamentNumber] INT            NOT NULL
);

